Use INSERT IGNORE INTO table . There's also INSERT … ON DUPLICATE KEY UPDATE syntax, and you can find explanations in 13.2.6.2 INSERT . ... <看更多>

In this post we will learn how to In this post we will learn How to Use MySQL INSERT INTO SELECT Statement ... ... <看更多>

I am extremely dubious that you have the problem you describe, but here goes: CREATE TEMPORARY TABLE t ( id BIGINT AUTO_INCREMENT PRIMARY KEY, . ... <看更多>

INSERT IGNORE INTO or REPLACE INTO MySQL operations are not really good practices. I advise you to replace with something else to INSERT if ... ... <看更多>